home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload Trio 2
/
Shareware Overload Trio Volume 2 (Chestnut CD-ROM).ISO
/
dir43
/
qsrc_dsk.zip
/
MODEL
/
BUDGET1.QPR
< prev
next >
Wrap
Text File
|
1992-01-13
|
1KB
|
22 lines
* ╓─────────────────────────────────────────────────────────╖
* ║ ║
* ║ BUDGET1.QPR ║
* ║ ║
* ╟─────────────────────────────────────────────────────────╢
* ║ Application Developed in _Using FoxPro 2_ ║
* ║ ║
* ║ Lisa C. Slater and Steven E. Arnott ║
* ║ ║
* ║ Copyright (c) 1991 Que Publishing ║
* ║ ║
* ╙─────────────────────────────────────────────────────────╜
SELECT DEPT.DEPTNAME, BUDGET.PERIOD, SUM(BUDGET.BUDGETAMT);
FROM BUDGET, DEPT;
WHERE DEPT.DEPTCODE = BUDGET.DEPTCODE;
GROUP BY BUDGET.PERIOD, BUDGET.DEPTCODE;
HAVING BUDGET.PERIOD=M.PERIOD;
ORDER BY BUDGET.PERIOD;
INTO CURSOR query1